Deploy the Web Application Utility and Creating Data Sources

Create the Data Source PALETTECONFIGDS for connecting PaletteConfig to OIPA database

  1. Select Services > Data.
  2. In the configuration section on the right, click New and select Generic Data Source.
  3. In the JDBC Data Source Properties pane that appears:
  4. Change the Name. This name can be anything, but has to be unique for the entire WebLogic server. If there are more than one OIPA instance on the server, then each instance should have a unique name.
  5. Change the JNDI Name to PALETTECONFIGDS. This name cannot be anything other than PALETTECONFIGDS.

    For Oracle Database:

    1. Select the driver type.

    2. Select the driver *Oracle Driver (Thin XA) for Service Connections; Version:Any

    3. Click Next again when Transaction options are displayed.

    4. In the Connection Properties pane:

    5. Enter the Database Name.

    6. Enter the Host Name of the database server.

    7. Enter the Port number of the database server.

    8. Enter the Database user name. This can be obtained from the database administrator who installed the databases.

    9. Enter both password entries. This can be obtained from the database administrator who installed the databases.

    For MS SQL Server Database

    1. Select the MS SQL Server database type.

    2. Click Next.

    3. Select the driver - MS SQL Server Driver (Type 4) Versions:2005 and later Other.

    4. Click Next.

    5. Click Next again when Transaction options are displayed.

    6. In the Connection Properties pane:

    7. Enter the DatabaseName.

    8. Enter the HostName of the database server.

    9. Enter the Port number of the database server.

    10. Enter the Databaseuser name. This can be obtained from the database administrator who installed the databases.

    11. Enter both password entries. This can be obtained from the database administrator who installed the databases.

  6. Click Next.
  7. On the next page Test Database Connection with the URL, as for example: jdbc:sqlserver://fsgbu-mum-420.snbomprshared1.gbucdsint02bom.oraclevcn.com:1600.
  8. Test the database connection.
  9. Click Next.
  10. In the Select Targets pane select the checkbox for the server that will host the Web Application Utility.
  11. Select Finish.

Create the Data Source PALETTECONFIGIVSDS for IVS

  1. Select Services > Data.
  2. In the configuration section on the right, click New and select Generic Data Source.
  3. In the JDBC Data Source Properties pane that appears:
  4. Change the Name. This name can be anything, but has to be unique for the entire WebLogic server. If there are more than one OIPA instance on the server, then each instance should have a unique name.
  5. Change the JNDI Name to PALETTECONFIGIVSDS. This name cannot be anything other than PALETTECONFIGIVSDS.

    For Oracle Database:

    1. Select the driver type.

    2. Select the driver "*Oracle Driver (Thin XA) for Service Connections; Version:Any"

    3. Click Next again when Transaction options are displayed.

    4. In the Connection Properties pane:

    5. Enter the Database Name.

    6. Enter the Host Name of the database server.

    7. Enter the Port number of the database server.

    8. Enter the Database user name. This can be obtained from the database administrator who installed the databases.

    9. Enter both password entries. This can be obtained from the database administrator who installed the databases.

    For MS SQL Server Database

    1. Select the MS SQL Server database type.

    2. Click Next.

    3. Select the driver - MS SQL Server Driver (Type 4) Versions:2005 and later Other.

    4. Click Next.

    5. Click Next again when Transaction options are displayed.

    6. In the Connection Properties pane:

    7. Enter the DatabaseName.

    8. Enter the HostName of the database server.

    9. Enter the Port number of the database server.

    10. Enter the Databaseuser name. This can be obtained from the database administrator who installed the databases.

    11. Enter both password entries. This can be obtained from the database administrator who installed the databases.

  6. Click Next.
  7. On the next page Test Database Connection with the URL, as for example: jdbc:sqlserver://fsgbu-mum-420.snbomprshared1.gbucdsint02bom.oraclevcn.com:1600.
  8. Test the database connection.
  9. Click Next.
  10. In the Select Targets pane select the checkbox for the server that will host the Web Application Utility
  11. Select Finish.

Deploy the Web Application Utility

  1. Using the navigation tree on the left, select Deployments.
  2. In the configuration section on the right, select Install.
  3. In the Install Application Assistant, locate the PaletteConfig.war file.
  4. Click Next.
  5. For the Targeting style keep the default of Install this deployment as an application.

  6. Click Next.

  7. For the Deployment Target, select the checkbox for the server that will host the Web Application Utility.

Note: Make sure PaletteConfig is deployed to the same sever where the above library is deployed.

  1. Click Next.
  2. Change the application name if needed.
  3. Click Next.
  4. Select Finish.

Preparing Deployments

  1. Using the navigation tree on the left, select Deployments.
  2. Select recently deployed deployments.
  3. Click Start and select Servicing All Requests.

Start the Servers

  1. In the WebLogic Admin Console, navigate to Monitoring Tree > Environment > Servers > <Select the server> Start.

  2. Once the server state changed to running, Navigate to Edit Tree >Deployments > App Deployments > Application Management – Monitoring Tree and ensure the state is active for the respective deployment.

  3. If the state is prepared or some thing else other than active, stop the deployment and start it.

  4. Now restart the server.

Important: When configuring the Rules Palette environment use the URL of the PaletteConfig server. The Web Application Utility must always be running in order for users to access the Rules Palette..

Note: Refer to the 12.2.0.0 OIPA Document Generator for document generation feature.

Troubleshoot (Common Issues)

Connection test failed. Listener refused the connection with the following error: ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

In case of above error while creating Oracle data source, please ensure JDBC URL is as mentioned below

jdbc:oracle:thin:@hostname:1521:orcl